|
400
|
Can I change the format of date to be shown in the control
with List1 do
begin
with Columns do
begin
Add('Default');
with (IUnknown(Add('Format.1')) as EXLISTLib_TLB.Column) do
begin
ComputedField := '%0';
FormatColumn := 'dateF(value) replace `/` with `-`';
end;
with (IUnknown(Add('Format.2')) as EXLISTLib_TLB.Column) do
begin
ComputedField := '%0';
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := '`<b>`+ shortdate(value) + `</b> ` + timeF(value)';
end;
with (IUnknown(Add('Format.3')) as EXLISTLib_TLB.Column) do
begin
ComputedField := '%0';
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := '( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `F' +
'r`; 6 : `Sa`) )';
end;
end;
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('1/2/2001 10:00:00 AM');
end;
end
|
|
399
|
How can I put a picture on the cell's background (method 3)
with List1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
VisualAppearance.Add(2,'CP:1 0 0 -164 0');
with Columns do
begin
Add('column');
with (IUnknown(Add('column')) as EXLISTLib_TLB.Column) do
begin
Alignment := EXLISTLib_TLB.CenterAlignment;
HeaderAlignment := EXLISTLib_TLB.CenterAlignment;
end;
end;
with Items do
begin
i := Add(Null);
SelectableItem[i] := False;
Caption[i,OleVariant(1)] := 'caption';
CellBackColor[i,OleVariant(1)] := $2000000;
end;
end
|
|
398
|
How can I put a picture on the cell's background (method 2)
with List1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
with Columns do
begin
Add('column');
Add('column');
end;
with Items do
begin
i := Add(Null);
SelectableItem[i] := False;
Caption[i,OleVariant(1)] := 'caption';
CellBackColor[i,OleVariant(1)] := $1000000;
CellPicture[i,OleVariant(1)] := List1.ExecuteTemplate('loadpicture(`c:\exontrol\images\auction.gif`)');
CellPictureWidth[i,OleVariant(1)] := 128;
CellPictureHeight[i,OleVariant(1)] := List1.DefaultItemHeight;
end;
end
|
|
397
|
How can I put a picture on the cell's background (method 1)
with List1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
with Columns do
begin
Add('column');
with (IUnknown(Add('column')) as EXLISTLib_TLB.Column) do
begin
Alignment := EXLISTLib_TLB.CenterAlignment;
HeaderAlignment := EXLISTLib_TLB.CenterAlignment;
end;
end;
with Items do
begin
i := Add(Null);
SelectableItem[i] := False;
Caption[i,OleVariant(1)] := 'caption';
CellBackColor[i,OleVariant(1)] := $1000000;
end;
end
|
|
396
|
How do I access the cells, or how do I get the values in the columns
with List1 do
begin
with Columns do
begin
Add('C1');
Add('C2');
Add('C3');
end;
with Items do
begin
h := Add('Item 1');
Caption[h,OleVariant(1)] := 'SubItem 1.1';
Caption[h,OleVariant(2)] := 'SubItem 1.2';
OutputDebugString( Caption[h,OleVariant(2)] );
end;
end
|
|
395
|
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
with List1 do
begin
BeginUpdate();
with ConditionalFormats.Add('1','K1') do
begin
BackColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
end;
with ConditionalFormats.Add('1','K2') do
begin
BackColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($2);
end;
MarkSearchColumn := False;
DrawGridLines := EXLISTLib_TLB.GridLinesEnum($fffffffc Or Integer(EXLISTLib_TLB.exVLines));
with Columns do
begin
Add('Column 1');
Add('Column 2');
Add('Column 3');
end;
with Items do
begin
Add(Null);
Add(Null);
Add(Null);
end;
EndUpdate();
end
|
|
394
|
How can I get the list of items as they are displayed
with List1 do
begin
BeginUpdate();
BackColorAlternate := RGB(240,240,240);
Columns.Add('Names');
with Items do
begin
Add('Mantel');
Add('Mechanik');
Add('Motor');
Add('Murks');
Add('Märchen');
Add('Möhren');
Add('Mühle');
end;
Columns.Item[OleVariant(0)].SortOrder := EXLISTLib_TLB.SortAscending;
EndUpdate();
OutputDebugString( GetItems(OleVariant(1)) );
end
|
|
393
|
Is posible to reduce the size of the picture to be shown in the column's caption
with List1 do
begin
BeginUpdate();
HTMLPicture['pic1'] := 'c:\exontrol\images\zipdisk.gif';
HeaderHeight := 48;
(IUnknown(Columns.Add('DefaultSize')) as EXLISTLib_TLB.Column).HTMLCaption := 'Default-Size <img>pic1</img> Picture';
(IUnknown(Columns.Add('CustomSize')) as EXLISTLib_TLB.Column).HTMLCaption := 'Custom-Size <img>pic1:16</img> Picture';
EndUpdate();
end
|
|
392
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
with List1 do
begin
BeginUpdate();
MarkSearchColumn := False;
with ConditionalFormats.Add('1',Null) do
begin
Bold := True;
ForeColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
end;
Columns.Add('C1');
with (IUnknown(Columns.Add('C2')) as EXLISTLib_TLB.Column) do
begin
HeaderBold := True;
HTMLCaption := '<fgcolor=FF0000>C2';
end;
with Items do
begin
Caption[Add(OleVariant(10)),OleVariant(1)] := OleVariant(11);
Caption[Add(OleVariant(12)),OleVariant(1)] := OleVariant(13);
end;
EndUpdate();
end
|
|
391
|
Is it possible to limit the height of item while resizing the row
// AddItem event - Occurs after a new Item is inserted to Items collection.
procedure TForm1.List1AddItem(ASender: TObject; Item : Integer);
begin
with List1 do
begin
Items.ItemMinHeight[Item] := 18;
Items.ItemMaxHeight[Item] := 72;
end
end;
with List1 do
begin
BeginUpdate();
ItemsAllowSizing := EXLISTLib_TLB.exResizeItem;
ScrollBySingleLine := False;
BackColorAlternate := RGB(240,240,240);
Columns.Add('Names');
with Items do
begin
Add('Mantel');
Add('Mechanik');
Add('Motor');
Add('Murks');
Add('Märchen');
Add('Möhren');
Add('Mühle');
end;
Columns.Item[OleVariant(0)].SortOrder := EXLISTLib_TLB.SortAscending;
EndUpdate();
end
|
|
390
|
Can I specify un-sortable items so they keep their position once the user sorts the columns
with List1 do
begin
(IUnknown(Columns.Add('Def')) as EXLISTLib_TLB.Column).SortType := EXLISTLib_TLB.SortNumeric;
with Items do
begin
SortableItem[Add('Unsortable')] := False;
Add(OleVariant(1));
Add(OleVariant(2));
Add(OleVariant(3));
end;
end
|
|
389
|
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state is changed.
procedure TForm1.List1CellStateChanged(ASender: TObject; ItemIndex : Integer;ColIndex : Integer);
begin
with List1 do
begin
Items.SelectItem[ItemIndex] := True;
end
end;
with List1 do
begin
(IUnknown(Columns.Add('Check')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellHasCheckBox] := OleVariant(True);
with Items do
begin
Add(OleVariant(0));
Add(OleVariant(1));
Add(OleVariant(2));
Add(OleVariant(3));
end;
end
|
|
388
|
Does your control supports multiple lines tooltip
with List1 do
begin
HTMLPicture['pic1'] := 'c:\exontrol\images\zipdisk.gif';
ToolTipDelay := 1;
(IUnknown(Columns.Add('tootip')) as EXLISTLib_TLB.Column).ToolTip := '<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, i' +
'cons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>';
end
|
|
387
|
How can I prevent highlighting the column from the cursor - point
with List1 do
begin
VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJg' +
'EgI=');
Background[EXLISTLib_TLB.exCursorHoverColumn] := $1000000;
(IUnknown(Columns.Add('S')) as EXLISTLib_TLB.Column).Width := 32;
(IUnknown(Columns.Add('Level 1')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('Level 2')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('Level 3')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
(IUnknown(Columns.Add('E1')) as EXLISTLib_TLB.Column).Width := 32;
(IUnknown(Columns.Add('E2')) as EXLISTLib_TLB.Column).Width := 32;
(IUnknown(Columns.Add('E3')) as EXLISTLib_TLB.Column).Width := 32;
(IUnknown(Columns.Add('E4')) as EXLISTLib_TLB.Column).Width := 32;
end
|
|
386
|
Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.List1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
with List1 do
begin
ShowToolTip(ItemFromPoint[-1,-1,c,hit],'','8','8',Null);
end
end;
with List1 do
begin
BeginUpdate();
Columns.Add('Def');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 3');
end;
EndUpdate();
end
|
|
385
|
Is it possible to prevent covering the colors by selected rows
with List1 do
begin
SelBackMode := EXLISTLib_TLB.exTransparent;
BackColorAlternate := RGB(240,240,240);
Columns.Add('Column');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 3');
Add('Item 4');
Add('Item 5');
end;
end
|
|
384
|
Can I use PNG images to display pictures in the control
with List1 do
begin
HTMLPicture['pic1'] := 'c:\exontrol\images\card.png';
HeaderHeight := 48;
(IUnknown(Columns.Add('ColumnName')) as EXLISTLib_TLB.Column).HTMLCaption := '<b>HTML</b> Column <img>pic1</img> Picture';
end
|
|
383
|
Does your control support conditional format and computed fields
with List1 do
begin
BeginUpdate();
MarkSearchColumn := False;
with ConditionalFormats do
begin
with Add('%1 >4',Null) do
begin
Bold := True;
StrikeOut := True;
ForeColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
end;
with Add('%2 > 4',Null) do
begin
Bold := True;
StrikeOut := True;
ForeColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($2);
end;
with Add('%3 > 4',Null) do
begin
Bold := True;
StrikeOut := True;
ForeColor := $ff;
ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($3);
end;
end;
with Columns do
begin
Add('Name');
with (IUnknown(Add('A')) as EXLISTLib_TLB.Column) do
begin
SortType := EXLISTLib_TLB.SortNumeric;
AllowSizing := False;
Width := 36;
FormatColumn := 'len(value) ? value + '' +''';
end;
with (IUnknown(Add('B')) as EXLISTLib_TLB.Column) do
begin
SortType := EXLISTLib_TLB.SortNumeric;
AllowSizing := False;
Width := 36;
FormatColumn := 'len(value) ? value + '' +''';
end;
with (IUnknown(Add('C')) as EXLISTLib_TLB.Column) do
begin
SortType := EXLISTLib_TLB.SortNumeric;
AllowSizing := False;
Width := 36;
FormatColumn := 'len(value) ? value + '' =''';
end;
with (IUnknown(Add('A+B+C')) as EXLISTLib_TLB.Column) do
begin
SortType := EXLISTLib_TLB.SortNumeric;
AllowSizing := False;
Width := 64;
ComputedField := '%1+%2+%3';
FormatColumn := '((0:=dbl(value)) < 10? ''<fgcolor=808080><font ;7>'' :''<b>'') + currency(=:0)';
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
end;
end;
with Items do
begin
h1 := Add('Item 1');
Caption[h1,OleVariant(1)] := OleVariant(7);
Caption[h1,OleVariant(2)] := OleVariant(3);
Caption[h1,OleVariant(3)] := OleVariant(1);
h1 := Add('Item 2');
Caption[h1,OleVariant(1)] := OleVariant(2);
Caption[h1,OleVariant(2)] := OleVariant(5);
Caption[h1,OleVariant(3)] := OleVariant(12);
h1 := Add('Item 3');
Caption[h1,OleVariant(1)] := OleVariant(2);
Caption[h1,OleVariant(2)] := OleVariant(2);
Caption[h1,OleVariant(3)] := OleVariant(4);
h1 := Add('Item 4');
Caption[h1,OleVariant(1)] := OleVariant(2);
Caption[h1,OleVariant(2)] := OleVariant(9);
Caption[h1,OleVariant(3)] := OleVariant(4);
end;
EndUpdate();
end
|
|
382
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
with List1 do
begin
BeginUpdate();
ScrollBars := EXLISTLib_TLB.DisableBoth;
with Columns do
begin
Add('C1');
Add('C2');
Add('C3');
Add('C4');
Add('C5');
Add('C6');
Add('C7');
Add('C8');
end;
RightToLeft := True;
EndUpdate();
end
|
|
381
|
Can I display the cell's check box after the text
with List1 do
begin
with (IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column) do
begin
Def[EXLISTLib_TLB.exCellHasCheckBox] := OleVariant(True);
Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,check';
end;
with Items do
begin
CellHasCheckBox[Add('Caption 1'),OleVariant(0)] := True;
CellHasCheckBox[Add('Caption 2'),OleVariant(0)] := True;
end;
end
|
|
380
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
with List1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
(IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,check,icon,icons,picture';
with Items do
begin
h := Add('Text');
CellImage[h,OleVariant(0)] := 1;
CellHasCheckBox[h,OleVariant(0)] := True;
end;
end
|
|
379
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
with List1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
(IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,icon,check,icons,picture';
with Items do
begin
h := Add('Text');
CellImage[h,OleVariant(0)] := 1;
end;
end
|
|
378
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
with List1 do
begin
BeginUpdate();
ScrollBars := EXLISTLib_TLB.DisableBoth;
with Columns do
begin
Add('C1');
Add('C2');
Add('C3');
Add('C4');
Add('C5');
Add('C6');
Add('C7');
Add('C8');
end;
RightToLeft := True;
EndUpdate();
end
|
|
377
|
How can I change the foreground color for a particular column
with List1 do
begin
with Columns do
begin
Add('Column 1');
(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderForeColor] := OleVariant(8439039);
Add('Column 3');
end;
end
|
|
376
|
How can I change the background color for a particular column
with List1 do
begin
with Columns do
begin
Add('Column 1');
(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderBackColor] := OleVariant(8439039);
Add('Column 3');
end;
end
|
|
375
|
How can I display the column using currency format and enlarge the font for certain values
with List1 do
begin
with (IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column) do
begin
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := 'len(value) ? ((0:=dbl(value)) < 10 ? ''<fgcolor=808080><font ;7>'' : ''<b>'') + currency(=:0)';
end;
with Items do
begin
Add('1.23');
Add('2.34');
Add('9.94');
Add('11.94');
Add('1000');
end;
end
|
|
374
|
How can I highlight only parts of the cells
with List1 do
begin
with (IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column) do
begin
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := 'value replace ''hil'' with ''<fgcolor=FF0000><b>hil</b></fgcolor>''';
end;
with Items do
begin
h := Add('Root');
Add('Child 1');
Add('Child 2');
Add('Child 3');
end;
end
|
|
373
|
How can I get the number of occurrences of a specified string in the cell
with List1 do
begin
Columns.Add('');
with (IUnknown(Columns.Add('occurrences')) as EXLISTLib_TLB.Column) do
begin
ComputedField := 'lower(%0) count ''o''';
FormatColumn := '''contains '' + value + '' of \''o\'' chars''';
end;
with Items do
begin
h := Add('Root');
Add('Child 1 oooof the root');
Add('Child 2');
Add('Child 3');
end;
end
|
|
372
|
How can I display dates in my format
with List1 do
begin
with (IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column) do
begin
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := '''<b>'' + year(0:=date(value)) + ''</b><fgcolor=808080><font ;6> ('' + month(=:0) + '' - '' + day(=:0) +'')''';
end;
with Items do
begin
Add('1/21/2001');
Add('2/22/2002');
Add('3/13/2003');
Add('4/24/2004');
end;
end
|
|
371
|
How can I display dates in short format
with List1 do
begin
(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).FormatColumn := 'shortdate(value)';
with Items do
begin
Add('1/1/2001');
Add('2/2/2002');
Add('3/3/2003');
Add('4/4/2004');
end;
end
|
|
370
|
How can I display dates in long format
with List1 do
begin
(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).FormatColumn := 'longdate(value)';
with Items do
begin
Add('1/1/2001');
Add('2/2/2002');
Add('3/3/2003');
Add('4/4/2004');
end;
end
|
|
369
|
How can I display only the right part of the cell
with List1 do
begin
Columns.Add('');
with (IUnknown(Columns.Add('Right')) as EXLISTLib_TLB.Column) do
begin
ComputedField := '%0 right 2';
FormatColumn := '''"'' + value + ''"''';
end;
with Items do
begin
h := Add('Root');
Add('Child 1');
Add('Child 2');
Add('SChild 3');
end;
end
|
|
368
|
How can I display only the left part of the cell
with List1 do
begin
Columns.Add('');
(IUnknown(Columns.Add('Left')) as EXLISTLib_TLB.Column).ComputedField := '%0 left 2';
with Items do
begin
h := Add('Root');
Add('Child 1');
Add('Child 2');
Add('SChild 3');
end;
end
|
|
367
|
How can I display true or false instead 0 and -1
with List1 do
begin
(IUnknown(Columns.Add('Boolean')) as EXLISTLib_TLB.Column).FormatColumn := 'value != 0 ? ''true'' : ''false''';
with Items do
begin
Add(OleVariant(True));
Add(OleVariant(False));
Add(OleVariant(True));
Add(OleVariant(0));
Add(OleVariant(1));
end;
end
|
|
366
|
How can I display icons or images instead numbers
with List1 do
begin
Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' +
'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' +
'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' +
'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
with (IUnknown(Columns.Add('Icons')) as EXLISTLib_TLB.Column) do
begin
Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
FormatColumn := '''The cell displays the icon <img>''+value+''</img> instead '' + value';
end;
with Items do
begin
Add(OleVariant(1));
Add(OleVariant(2));
Add(OleVariant(3));
end;
end
|
|
365
|
How can I display the column using currency
with List1 do
begin
(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).FormatColumn := 'currency(dbl(value))';
with Items do
begin
Add('1.23');
Add('2.34');
Add('0');
Add(OleVariant(5));
Add('10000.99');
end;
end
|
|
364
|
Is is possible to use HTML tags to display in the filter caption
with List1 do
begin
BeginUpdate();
FilterBarPromptVisible := True;
FilterBarCaption := 'This is a bit of text being displayed in the filter bar.';
Columns.Add('');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 3');
end;
EndUpdate();
end
|
|
363
|
How can I find the number of items after filtering
with List1 do
begin
BeginUpdate();
Columns.Add('');
with Items do
begin
h := Add('');
Caption[h,OleVariant(0)] := OleVariant(VisibleItemCount);
end;
EndUpdate();
end
|
|
362
|
How can I change the filter caption
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAll);
FilterBarPromptPattern := 'london robert';
FilterBarCaption := '<r>Found: ... ';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
361
|
While using the filter prompt is it is possible to use wild characters
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptPattern;
FilterBarPromptPattern := 'lon* seat*';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
360
|
How can I list all items that contains any of specified words, not necessary at the beggining
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptStartWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
FilterBarPromptPattern := 'london davolio';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
359
|
How can I list all items that contains any of specified words, not strings
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
FilterBarPromptPattern := 'london nancy';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
358
|
How can I list all items that contains all specified words, not strings
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAll);
FilterBarPromptPattern := 'london robert';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
357
|
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptCaseSensitive) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
FilterBarPromptPattern := 'Anne';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
356
|
Is it possible to list only items that ends with any of specified strings
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptEndWith;
FilterBarPromptColumns := '0';
FilterBarPromptPattern := 'Fuller';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
355
|
Is it possible to list only items that ends with any of specified strings
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptEndWith;
FilterBarPromptColumns := '0';
FilterBarPromptPattern := 'Fuller';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
354
|
Is it possible to list only items that starts with any of specified strings
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptStartWith;
FilterBarPromptColumns := '0';
FilterBarPromptPattern := 'An M';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
353
|
Is it possible to list only items that starts with specified string
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptStartWith;
FilterBarPromptColumns := '0';
FilterBarPromptPattern := 'A';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
352
|
How can I specify that the list should include any of the seqeunces in the pattern
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptContainsAny;
FilterBarPromptPattern := 'london seattle';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
351
|
How can I specify that all sequences in the filter pattern must be included in the list
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptType := EXLISTLib_TLB.exFilterPromptContainsAll;
FilterBarPromptPattern := 'london manager';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
350
|
How do I change at runtime the filter prompt
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptPattern := 'london manager';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
349
|
How do I specify to filter only a single column when using the filter prompt
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPromptColumns := '2,3';
FilterBarPromptPattern := 'london';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
348
|
How do I change the prompt or the caption being displayed in the filter bar
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
FilterBarPrompt := 'changed';
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
EndUpdate();
end
|
|
347
|
How do I enable the filter prompt feature
with List1 do
begin
BeginUpdate();
ColumnAutoResize := True;
ContinueColumnScroll := False;
MarkSearchColumn := False;
SearchColumnIndex := 1;
FilterBarPromptVisible := True;
with Columns do
begin
(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
Add('City');
end;
with Items do
begin
h0 := Add('Nancy Davolio');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Andrew Fuller');
Caption[h0,OleVariant(1)] := 'Vice President, Sales';
Caption[h0,OleVariant(2)] := 'Tacoma';
SelectItem[h0] := True;
h0 := Add('Janet Leverling');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Kirkland';
h0 := Add('Margaret Peacock');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'Redmond';
h0 := Add('Steven Buchanan');
Caption[h0,OleVariant(1)] := 'Sales Manager';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Michael Suyama');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Robert King');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
h0 := Add('Laura Callahan');
Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
Caption[h0,OleVariant(2)] := 'Seattle';
h0 := Add('Anne Dodsworth');
Caption[h0,OleVariant(1)] := 'Sales Representative';
Caption[h0,OleVariant(2)] := 'London';
end;
EndUpdate();
end
|
|
346
|
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
with List1 do
begin
BeginUpdate();
DrawGridLines := EXLISTLib_TLB.exAllLines;
GridLineStyle := Integer(EXLISTLib_TLB.exGridLinesVSolid) Or Integer(EXLISTLib_TLB.exGridLinesHDot4);
Columns.Add('C1');
Columns.Add('C2');
Columns.Add('C3');
with Items do
begin
h := Add('Item 1');
Caption[h,OleVariant(1)] := 'SubItem 1.2';
Caption[h,OleVariant(2)] := 'SubItem 1.3';
h := Add('Item 2');
Caption[h,OleVariant(1)] := 'SubItem 2.2';
Caption[h,OleVariant(2)] := 'SubItem 2.3';
end;
EndUpdate();
end
|
|
345
|
Is it possible to change the style for the grid lines, for instance to be solid not dotted
with List1 do
begin
BeginUpdate();
DrawGridLines := EXLISTLib_TLB.exAllLines;
GridLineStyle := EXLISTLib_TLB.exGridLinesSolid;
Columns.Add('Column');
EndUpdate();
end
|
|
344
|
How can I filter programatically using more columns
with List1 do
begin
BeginUpdate();
MarkSearchColumn := False;
with Columns do
begin
Add('Car');
Add('Equipment');
end;
with Items do
begin
Caption[Add('Mazda'),OleVariant(1)] := 'Air Bag';
Caption[Add('Toyota'),OleVariant(1)] := 'Air Bag,Air condition';
Caption[Add('Ford'),OleVariant(1)] := 'Air condition';
Caption[Add('Nissan'),OleVariant(1)] := 'Air Bag,ABS,ESP';
Caption[Add('Mazda'),OleVariant(1)] := 'Air Bag, ABS,ESP';
Caption[Add('Mazda'),OleVariant(1)] := 'ABS,ESP';
end;
with Columns.Item['Car'] do
begin
FilterType := EXLISTLib_TLB.exFilter;
Filter := 'Mazda';
end;
with Columns.Item['Equipment'] do
begin
FilterType := EXLISTLib_TLB.exPattern;
Filter := '*ABS*|*ESP*';
end;
ApplyFilter();
EndUpdate();
end
|
|
343
|
How do I find an item based on my extra data
with List1 do
begin
Columns.Add('Default');
with Items do
begin
Add('Item 1');
Add('Item 2');
ItemData[Add('Item 3')] := OleVariant(1234);
Add('Item 4');
ItemBold[FindItemData[OleVariant(1234),Null]] := True;
end;
end
|
|
342
|
How do I print the control's content
with List1 do
begin
BeginUpdate();
Columns.Add('Number');
(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'len(%0) ? currency(dbl(%0)) : ''''';
with Items do
begin
Add('1.23');
Add('2.34');
Add('0');
ItemBackColor[Add(Null)] := $8080ff;
Add('10000.99');
end;
EndUpdate();
with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
begin
PrintExt := (IUnknown(List1.DefaultInterface) as EXLISTLib_TLB.List);
Preview();
end;
end
|
|
341
|
How can I display the currency only for not empty cells
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'len(%0) ? currency(dbl(%0)) : ''''';
with Items do
begin
Add('1.23');
Add('2.34');
Add('0');
ItemBackColor[Add(Null)] := $8080ff;
Add('10000.99');
end;
end
|
|
340
|
Is there a function to display the number of days between two date including the number of hours
with List1 do
begin
(IUnknown(Columns.Add('Start')) as EXLISTLib_TLB.Column).Width := 32;
Columns.Add('End');
(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '''' : str(=:1) + '' day(s)'') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? '' and '' : ''' +
''') + =:3 + '' hour(s)'' : '''' )';
with Items do
begin
h := Add('1/11/2001');
Caption[h,OleVariant(1)] := '1/14/2001';
h := Add('2/22/2002 12:00:00 PM');
Caption[h,OleVariant(1)] := '3/14/2002 1:00:00 PM';
h := Add('3/13/2003');
Caption[h,OleVariant(1)] := '4/11/2003 11:00:00 AM';
end;
end
|
|
339
|
Is there a function to display the number of days between two date including the number of hours
with List1 do
begin
Columns.Add('Start');
Columns.Add('End');
(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '"D " + int(date(%1)-date(%0)) + " H " + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))';
with Items do
begin
h := Add('1/11/2001');
Caption[h,OleVariant(1)] := '1/14/2001 11:00:00 PM';
h := Add('2/22/2002 12:00:00 PM');
Caption[h,OleVariant(1)] := '3/14/2002 1:00:00 PM';
h := Add('3/13/2003');
Caption[h,OleVariant(1)] := '4/11/2003 11:00:00 AM';
end;
end
|
|
338
|
How can I display the number of days between two dates
with List1 do
begin
Columns.Add('Start');
Columns.Add('End');
(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '(date(%1)-date(%0)) + '' days''';
with Items do
begin
h := Add('1/11/2001');
Caption[h,OleVariant(1)] := '1/14/2001';
h := Add('2/22/2002');
Caption[h,OleVariant(1)] := '3/14/2002';
h := Add('3/13/2003');
Caption[h,OleVariant(1)] := '4/11/2003';
end;
end
|
|
337
|
How can I get second part of the date
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Second')) as EXLISTLib_TLB.Column).ComputedField := 'sec(date(%0))';
with Items do
begin
Add('1/11/2001 10:10:00 AM');
Add('2/22/2002 11:01:22 AM');
Add('3/13/2003 12:23:01 PM');
Add('4/14/2004 1:11:59 PM');
end;
end
|
|
336
|
How can I get minute part of the date
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Minute')) as EXLISTLib_TLB.Column).ComputedField := 'min(date(%0))';
with Items do
begin
Add('1/11/2001 10:10:00 AM');
Add('2/22/2002 11:01:00 AM');
Add('3/13/2003 12:23:00 PM');
Add('4/14/2004 1:11:00 PM');
end;
end
|
|
335
|
How can I check the hour part only so I know it was afternoon
with List1 do
begin
ConditionalFormats.Add('hour(%0)>=12',Null).Bold := True;
Columns.Add('Date');
(IUnknown(Columns.Add('Hour')) as EXLISTLib_TLB.Column).ComputedField := 'hour(%0)';
with Items do
begin
Add('1/11/2001 10:00:00 AM');
Add('2/22/2002 11:00:00 AM');
Add('3/13/2003 12:00:00 PM');
Add('4/14/2004 1:00:00 PM');
end;
end
|
|
334
|
What about a function to get the day in the week, or days since Sunday
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('WeekDay')) as EXLISTLib_TLB.Column).ComputedField := 'weekday(%0)';
with Items do
begin
Add('1/11/2001 10:00:00 AM');
Add('2/22/2002 11:00:00 AM');
Add('3/13/2003 12:00:00 PM');
Add('4/14/2004 1:00:00 PM');
end;
end
|
|
333
|
Is there any function to get the day of the year or number of days since January 1st
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Day since January 1st')) as EXLISTLib_TLB.Column).ComputedField := 'yearday(%0)';
with Items do
begin
Add('1/11/2001 10:00:00 AM');
Add('2/22/2002 11:00:00 AM');
Add('3/13/2003 12:00:00 PM');
Add('4/14/2004 1:00:00 PM');
end;
end
|
|
332
|
How can I display only the day of the date
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Day')) as EXLISTLib_TLB.Column).ComputedField := 'day(%0)';
with Items do
begin
Add('1/11/2001 10:00:00 AM');
Add('2/22/2002 11:00:00 AM');
Add('3/13/2003 12:00:00 PM');
Add('4/14/2004 1:00:00 PM');
end;
end
|
|
331
|
How can I display only the month of the date
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Month')) as EXLISTLib_TLB.Column).ComputedField := 'month(%0)';
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('2/2/2002 11:00:00 AM');
Add('3/3/2003 12:00:00 PM');
Add('4/4/2004 1:00:00 PM');
end;
end
|
|
330
|
How can I get only the year part from a date expression
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Year')) as EXLISTLib_TLB.Column).ComputedField := 'year(%0)';
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('2/2/2002 11:00:00 AM');
Add('3/3/2003 12:00:00 PM');
Add('4/4/2004 1:00:00 PM');
end;
end
|
|
329
|
Can I convert the expression to date
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).ComputedField := 'date(dbl(%0))';
with Items do
begin
Add('-1.98');
Add('30000.99');
Add('3561.23');
Add('1232.34');
end;
end
|
|
328
|
Can I convert the expression to a number, double or float
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Number + 2')) as EXLISTLib_TLB.Column).ComputedField := 'dbl(%0)+2';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
327
|
How can I display dates in long format
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('LongFormat')) as EXLISTLib_TLB.Column).ComputedField := 'longdate(%0)';
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('2/2/2002 11:00:00 AM');
Add('3/3/2003 12:00:00 PM');
Add('4/4/2004 1:00:00 PM');
end;
end
|
|
326
|
How can I display dates in short format
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('ShortFormat')) as EXLISTLib_TLB.Column).ComputedField := 'shortdate(%0)';
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('2/2/2002 11:00:00 AM');
Add('3/3/2003 12:00:00 PM');
Add('4/4/2004 1:00:00 PM');
end;
end
|
|
325
|
How can I display the time only of a date expression
with List1 do
begin
Columns.Add('Date');
(IUnknown(Columns.Add('Time')) as EXLISTLib_TLB.Column).ComputedField := '''time is:'' + time(date(%0))';
with Items do
begin
Add('1/1/2001 10:00:00 AM');
Add('2/2/2002 11:00:00 AM');
Add('3/3/2003 12:00:00 PM');
Add('4/4/2004 1:00:00 PM');
end;
end
|
|
324
|
Is there any function to display currencies, or money formatted as in the control panel
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'currency(dbl(%0))';
with Items do
begin
Add('1.23');
Add('2.34');
Add('10000.99');
end;
end
|
|
323
|
How can I convert the expression to a string so I can look into the date string expression for month's name
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Str')) as EXLISTLib_TLB.Column).ComputedField := 'str(%0) + '' AA''';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
322
|
Can I display the absolute value or positive part of the number
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Abs')) as EXLISTLib_TLB.Column).ComputedField := 'abs(%0)';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
321
|
Is there any function to get largest number with no fraction part that is not greater than the value
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Floor')) as EXLISTLib_TLB.Column).ComputedField := 'floor(%0)';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
320
|
Is there any function to round the values base on the .5 value
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Round')) as EXLISTLib_TLB.Column).ComputedField := 'round(%0)';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
319
|
How can I get or display the integer part of the cell
with List1 do
begin
Columns.Add('Number');
(IUnknown(Columns.Add('Int')) as EXLISTLib_TLB.Column).ComputedField := 'int(%0)';
with Items do
begin
Add('-1.98');
Add('0.99');
Add('1.23');
Add('2.34');
end;
end
|
|
318
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
with List1 do
begin
(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'proper(%0)';
with Items do
begin
h := Add('Item 1');
Add('item item');
Add('item item');
Add('item item');
end;
end
|
|
317
|
Is there any option to display cells in uppercase
with List1 do
begin
(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'upper(%0)';
with Items do
begin
h := Add('Item 1');
Add('Item 2');
Add('Item 3');
Add('Item 4 - child');
end;
end
|
|
316
|
Is there any option to display cells in lowercase
with List1 do
begin
(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'lower(%0)';
with Items do
begin
h := Add('Item 1');
Add('Item 2');
Add('Item 3');
Add('Item 4 - child');
end;
end
|
|
315
|
How can I mark the cells that has a specified type, ie strings only
with List1 do
begin
ConditionalFormats.Add('type(%0) = 8',Null).ForeColor := $ff;
Columns.Add('');
with Items do
begin
h := Add('Item 1');
Add('Item 2');
Add(OleVariant(2));
Add('Item 4 - child');
end;
end
|
|
314
|
How can I bold the items that contains data or those who displays empty strings
with List1 do
begin
ConditionalFormats.Add('not len(%1)=0',Null).Bold := True;
Columns.Add('C1');
Columns.Add('C2');
with Items do
begin
h := Add('Item 1');
Add('Item 2');
hC := Add('Item 3');
Caption[hC,OleVariant(1)] := '1';
Add('Item 3');
end;
end
|
|
313
|
Can I change the background color for items or cells that contains a specified string
with List1 do
begin
ConditionalFormats.Add('%0 contains ''hi''',Null).BackColor := $ff;
Columns.Add('');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 3');
Add('Item 4 - child');
end;
end
|
|
312
|
Is there any option to change the fore color for cells or items that ends with a specified string
with List1 do
begin
ConditionalFormats.Add('%0 endwith ''22''',Null).ForeColor := $ff;
Columns.Add('');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 1.22');
Add('Item 2.22');
end;
end
|
|
311
|
How can I highlight the cells or items that starts with a specified string
with List1 do
begin
ConditionalFormats.Add('%0 startwith ''C''',Null).Underline := True;
Columns.Add('');
with Items do
begin
Add('Item 1');
Add('CItem 2');
Add('Item 3');
Add('Item 4');
end;
end
|
|
310
|
How can I change the foreground color for a particular column
with List1 do
begin
with Columns do
begin
Add('Column 1');
(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderForeColor] := OleVariant(8439039);
Add('Column 3');
end;
end
|
|
309
|
How can I change the background color for a particular column
with List1 do
begin
with Columns do
begin
Add('Column 1');
(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderBackColor] := OleVariant(8439039);
Add('Column 3');
end;
end
|
|
308
|
How can I display the column's header using multiple lines
with List1 do
begin
HeaderHeight := 128;
HeaderSingleLine := False;
(IUnknown(Columns.Add('This is just a column that should break the header.')) as EXLISTLib_TLB.Column).Width := 32;
Columns.Add('This is just another column that should break the header.');
end
|
|
307
|
How can I align the text/caption on the scroll bar
with List1 do
begin
ScrollPartCaption[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exLowerBackPart] := 'left';
ScrollPartCaptionAlignment[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exLowerBackPart] := EXLISTLib_TLB.LeftAlignment;
ScrollPartCaption[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exUpperBackPart] := 'right';
ScrollPartCaptionAlignment[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exUpperBackPart] := EXLISTLib_TLB.RightAlignment;
ColumnAutoResize := False;
Columns.Add(1);
Columns.Add(2);
Columns.Add(3);
Columns.Add(4);
Columns.Add(5);
Columns.Add(6);
end
|
|
306
|
How do I select the next row/item
with List1 do
begin
Columns.Add('Column');
with Items do
begin
Add('Item 1');
Add('Item 2');
Add('Item 3');
SelectItem[NextVisibleItem[FocusItem]] := True;
end;
end
|
|
305
|
How do I enable resizing ( changing the height ) the items at runtime
with List1 do
begin
ItemsAllowSizing := EXLISTLib_TLB.exResizeItem;
DrawGridLines := EXLISTLib_TLB.exHLines;
ScrollBySingleLine := True;
Columns.Add('Column');
Items.Add('Item 1');
with Items do
begin
ItemHeight[Add('Item 2')] := 48;
end;
Items.Add('Item 3');
Items.Add('Item 4');
end
|
|
304
|
How do I enable resizing all the items at runtime
with List1 do
begin
ItemsAllowSizing := EXLISTLib_TLB.exResizeAllItems;
DrawGridLines := EXLISTLib_TLB.exHLines;
Columns.Add('Column');
Items.Add('Item 1');
with Items do
begin
ItemHeight[Add('Item 2')] := 48;
end;
Items.Add('Item 3');
end
|
|
303
|
How can I remove the filter
with List1 do
begin
with (IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column) do
begin
DisplayFilterButton := True;
FilterType := EXLISTLib_TLB.exBlanks;
end;
ApplyFilter();
ClearFilter();
end
|
|
302
|
How do I change the control's border, using your EBN files
with List1 do
begin
VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
Appearance := EXLISTLib_TLB.AppearanceEnum($1000000);
end
|
|
301
|
Can I change the style for break or divider line
with List1 do
begin
Columns.Add('Default');
with Items do
begin
Add('Item 1');
h := Add(Null);
ItemBreak[h] := EXLISTLib_TLB.DoubleLine;
SelectableItem[h] := False;
Add('Item 3');
end;
end
|